﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SCDbDataSet" targetNamespace="http://tempuri.org/SCDbDataSet.xsd" xmlns:mstns="http://tempuri.org/SCDbDataSet.xsd" xmlns="http://tempuri.org/SCDbDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SCDbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SCDbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SCResources.Properties.Settings.GlobalReference.Default.SCDbConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
        </Connections>
        <Tables />
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SCDbDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="SCDbDataSet" msprop:Generator_UserDSName="SCDbDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="AirInfo" msprop:Generator_TableClassName="AirInfoDataTable" msprop:Generator_TableVarName="tableAirInfo" msprop:Generator_TablePropName="AirInfo" msprop:Generator_RowDeletingName="AirInfoRowDeleting" msprop:Generator_UserTableName="AirInfo" msprop:Generator_RowChangingName="AirInfoRowChanging" msprop:Generator_RowEvHandlerName="AirInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="AirInfoRowDeleted" msprop:Generator_RowEvArgName="AirInfoRowChangeEvent" msprop:Generator_RowChangedName="AirInfoRowChanged" msprop:Generator_RowClassName="AirInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="NextAirDate" msprop:Generator_ColumnVarNameInTable="columnNextAirDate" msprop:Generator_ColumnPropNameInRow="NextAirDate" msprop:Generator_ColumnPropNameInTable="NextAirDateColumn" msprop:Generator_UserColumnName="NextAirDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Season" msprop:Generator_ColumnVarNameInTable="columnSeason" msprop:Generator_ColumnPropNameInRow="Season" msprop:Generator_ColumnPropNameInTable="SeasonColumn" msprop:Generator_UserColumnName="Season" type="xs:int" />
              <xs:element name="Episode" msprop:Generator_ColumnVarNameInTable="columnEpisode" msprop:Generator_ColumnPropNameInRow="Episode" msprop:Generator_ColumnPropNameInTable="EpisodeColumn" msprop:Generator_UserColumnName="Episode" type="xs:int" />
              <xs:element name="Frequency" msprop:Generator_ColumnVarNameInTable="columnFrequency" msprop:Generator_ColumnPropNameInRow="Frequency" msprop:Generator_ColumnPropNameInTable="FrequencyColumn" msprop:Generator_UserColumnName="Frequency" type="xs:int" default="0" minOccurs="0" />
              <xs:element name="SerieId" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSerieId" msprop:Generator_ColumnPropNameInRow="SerieId" msprop:Generator_ColumnPropNameInTable="SerieIdColumn" msprop:Generator_UserColumnName="SerieId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserInfo" msprop:Generator_TableClassName="UserInfoDataTable" msprop:Generator_TableVarName="tableUserInfo" msprop:Generator_TablePropName="UserInfo" msprop:Generator_RowDeletingName="UserInfoRowDeleting" msprop:Generator_UserTableName="UserInfo" msprop:Generator_RowChangingName="UserInfoRowChanging" msprop:Generator_RowEvHandlerName="UserInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="UserInfoRowDeleted" msprop:Generator_RowEvArgName="UserInfoRowChangeEvent" msprop:Generator_RowChangedName="UserInfoRowChanged" msprop:Generator_RowClassName="UserInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Season" msprop:Generator_ColumnVarNameInTable="columnSeason" msprop:Generator_ColumnPropNameInRow="Season" msprop:Generator_ColumnPropNameInTable="SeasonColumn" msprop:Generator_UserColumnName="Season" type="xs:int" />
              <xs:element name="Episode" msprop:Generator_ColumnVarNameInTable="columnEpisode" msprop:Generator_ColumnPropNameInRow="Episode" msprop:Generator_ColumnPropNameInTable="EpisodeColumn" msprop:Generator_UserColumnName="Episode" type="xs:int" />
              <xs:element name="SerieId" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSerieId" msprop:Generator_ColumnPropNameInRow="SerieId" msprop:Generator_ColumnPropNameInTable="SerieIdColumn" msprop:Generator_UserColumnName="SerieId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Series" msprop:Generator_TableClassName="SeriesDataTable" msprop:Generator_TableVarName="tableSeries" msprop:Generator_TablePropName="Series" msprop:Generator_RowDeletingName="SeriesRowDeleting" msprop:Generator_UserTableName="Series" msprop:Generator_RowChangingName="SeriesRowChanging" msprop:Generator_RowEvHandlerName="SeriesRowChangeEventHandler" msprop:Generator_RowDeletedName="SeriesRowDeleted" msprop:Generator_RowEvArgName="SeriesRowChangeEvent" msprop:Generator_RowChangedName="SeriesRowChanged" msprop:Generator_RowClassName="SeriesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cover" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="Cover" msprop:Generator_ColumnVarNameInTable="columnCover" msprop:Generator_ColumnPropNameInTable="CoverColumn" msprop:Generator_UserColumnName="Cover" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocalDirectory" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="LocalDirectory" msprop:Generator_ColumnVarNameInTable="columnLocalDirectory" msprop:Generator_ColumnPropNameInTable="LocalDirectoryColumn" msprop:Generator_UserColumnName="LocalDirectory" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AutoAirInfo" msprop:Generator_ColumnVarNameInTable="columnAutoAirInfo" msprop:Generator_ColumnPropNameInRow="AutoAirInfo" msprop:Generator_ColumnPropNameInTable="AutoAirInfoColumn" msprop:Generator_UserColumnName="AutoAirInfo" type="xs:boolean" default="true" />
              <xs:element name="ImdbId" msprop:Generator_ColumnVarNameInTable="columnImdbId" msprop:Generator_ColumnPropNameInRow="ImdbId" msprop:Generator_ColumnPropNameInTable="ImdbIdColumn" msprop:Generator_UserColumnName="ImdbId" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AirInfo" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Constraint2">
      <xs:selector xpath=".//mstns:AirInfo" />
      <xs:field xpath="mstns:SerieId" />
    </xs:unique>
    <xs:unique name="UserInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserInfo" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="UserInfo_Constraint2" msdata:ConstraintName="Constraint2">
      <xs:selector xpath=".//mstns:UserInfo" />
      <xs:field xpath="mstns:SerieId" />
    </xs:unique>
    <xs:unique name="Series_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Series" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:keyref name="FK_Series_UserInfo" refer="Series_Constraint1" msprop:rel_Generator_UserChildTable="UserInfo" msprop:rel_Generator_ChildPropName="GetUserInfoRows" msprop:rel_Generator_ParentPropName="SeriesRow" msprop:rel_Generator_UserRelationName="FK_Series_UserInfo" msprop:rel_Generator_RelationVarName="relationFK_Series_UserInfo" msprop:rel_Generator_UserParentTable="Series">
      <xs:selector xpath=".//mstns:UserInfo" />
      <xs:field xpath="mstns:SerieId" />
    </xs:keyref>
    <xs:keyref name="FK_Series_AirInfo" refer="Series_Constraint1" msprop:rel_Generator_UserChildTable="AirInfo" msprop:rel_Generator_ChildPropName="GetAirInfoRows" msprop:rel_Generator_ParentPropName="SeriesRow" msprop:rel_Generator_UserRelationName="FK_Series_AirInfo" msprop:rel_Generator_RelationVarName="relationFK_Series_AirInfo" msprop:rel_Generator_UserParentTable="Series">
      <xs:selector xpath=".//mstns:AirInfo" />
      <xs:field xpath="mstns:SerieId" />
    </xs:keyref>
  </xs:element>
</xs:schema>